SyMachine

Logical Entity Name | SyMachine
Default Table Name | SyMachine
Physical Only | NO
Owner | dbo
Definition |
Note |

SyMachine Columns

ColumnName | Domain | Datatype | NULL | Definition
mac_uid |  | int | NO |
mac_ip |  | varchar(50) | NO |
mac_name |  | varchar(30) | NO |
mac_date |  | datetime | NO |
mac_product |  | varchar(30) | NO |
mac_data |  | text | YES |
mac_version |  | varchar(50) | YES |
mac_status |  | tinyint | NO |
mac_online |  | bit | NO |
mac_online_timestamp |  | datetime | NO |
mac_last_ping_timestamp |  | datetime | NO |
mac_hostname |  | varchar(255) | YES |
ts |  | timestamp | NO |

SyMachine Primary and Unique Keys

Key Name | Key Type | Keys
IX_SyMachine_IP_Product | Index | mac_ip, mac_product
PK_SyMachine | PrimaryKey | mac_uid

SyMachine Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication

SyMachine Check Constraints

Check Constraint Name | CheckConstraint

SyMachine Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group | PRIMARY

SyMachine Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.SyMachine | NO |  |  |
Physical (Microsoft SQL Server) dbo.SyMachine | NO |  |  |

SyMachine Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | System

SyMachine Data Movement Rules

Name | Type | Rule Text/Value